Cannot find Create Relationship under Relationships menu due to removed.
Cause:
The 'Create Relationship' command has been removed.
Solution:
To create a relationship between two tables in Access 7.0, open the Relationships window, and drag the primary key field from the first table onto the foreign key field in the second table.
1) Select the 'Tools' menu and select 'Relationships'. (The Relationships window appears.)
The Relationships window
NOTE: If the database does not yet have any relationships defined, the 'Show Table' dialog box appears before the Relationships window.
2) Select the field from the first table.
NOTE: This will usually be the primary key field.
3) Drag that field onto the related field in the second table.
NOTE: The field in the second table is called the foreign key field.
4) Release the mouse button. (The Relationships dialog box appears.)
NOTE: The two fields must have the same data type and contain the same type of information, but they can have different names.
5) Make sure the field names are correct on the list.
6) (Optional) Do one of the following:
a) Select the 'Enforce Referential Integrity' check box to enforce referential integrity .
b) Select the 'Cascade Update Related Fields' check box to automatically update operations for related records.
c) Select the 'Cascade Delete Related Fields' check box to automatically delete operations for related records.
7) Click 'Create'.
8) Repeat steps 2) through 7) for each relationship to create.
9) Select the 'File' menu and select 'Save'.
10) Select the 'File' menu and select 'Close' to close the Relationships window.
